import pandas as pd

if __name__ == '__main__':
    cell = pd.read_excel("D:\\家宽\\oltpon对应小区\\OLTPON口对小区20250301(含PON口简称).xlsx", sheet_name='整理后',
                         usecols=["OLT-IP-PON", "小区ID"],
                         dtype=str)
    cell.rename(columns={'OLT-IP-PON': 'OLTIP+OLTPORT'}, inplace=True)
    cell = cell.drop_duplicates()
    cell.to_csv("D:\\中断输入\\OLTPON口对小区.csv", index=False)
